// sql语句

var sqlMap = {

// 用户
  user: {
  
    add: 'insert into user_table(id, name, password,user_number,user_type, the_car_number,sedan,car,motor_bus) values(0, ?, ?, ?, ?,0,0,0,0)',
    refer :'SELECT * FROM user_table',
    upd:'UPDATE user_table SET password = ?,name = ? WHERE id = ?',
    del:'DELETE FROM user_table where id=?'
  },
  //车辆表
  //(id,serial_number,license_plate_number,manufacturing_company,purchasing_date,model_of_car,the_total_mileage,fuel_cons,basic_maintenance_cost,road_toll,cumulative_total_cost,busload,carton_numbers,load_capacity,owner)
  vehicle:{
    add: 'insert into vehicle_table values(0,0,?,?,?,?,?,?,?,?,?,?,?,?,?)',
    refer :'SELECT * FROM vehicle_table',
    upd:'UPDATE vehicle_table SET license_plate_number=?,manufacturing_company=? purchasing_date=?, model_of_car=? ,the_total_mileage=?, fuel_cons=? ,basic_maintenance_cost=?, road_toll=? ,cumulative_total_cost=? ,busload=?, carton_numbers=?, load_capacity=?, owner=? WHERE id = ?',
    del:'DELETE FROM vehicle_table where id=?'
  }
};
module.exports = sqlMap;
//  //add: 'insert into user(id, name, age) values (0, ?, ?)'


























